Experienced KS1 and KS2 teacher currently teaching in Year Six. Specialist Leader for Mathematics across three Local Authorities.
All resources have been tried and tested. I'm open to suggestions and requests and aim to help anyone who requires it.
Please leave feedback and rate my resources.
Experienced KS1 and KS2 teacher currently teaching in Year Six. Specialist Leader for Mathematics across three Local Authorities.
All resources have been tried and tested. I'm open to suggestions and requests and aim to help anyone who requires it.
Please leave feedback and rate my resources.
A fully-resourced pub-quiz style quiz with nine rounds. Perfect for a bit of fun at the end of term.
History and Politics
Sport and Leisure
Entertainment
Picture Round (Supplied)
Music (link included)
Geography and Travel
Art and Literature
Science and Nature
General Knowledge
A fun PowerPoint delivers the questions and answers.
Answer sheets are provided for the teams
Picture Round and answers are included
Please leave feedback.
These are excel spreadsheets Gap Analysis documents for the May 2019 Year Six SATs Papers for GPS (including spelling).
**
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2019 SATs with that score. If it goes Purple with a White font, it means that child would have achieved a ‘More Able’ score for that tested subject.**
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 30 or 90 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable, including adding and removing rows. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken. This password will not be given out, but I am more than happy to make adaptations or changes for you, provided you show proof of purchase. All of my contact details are in the resource.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.
Included in this bundle are three complete suites of Gap Analysis / Question Level Analysis grids for the 2016, 2017, 2018 and 2019 KS1 SATs.
Every paper, every question.
Grids change colour depending on whether questions have been answered correctly and the grids auto calculate scores, indicating pass/fail or greater depth.
Please see individual resources for more details.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
Applicable for the 2021-2022 WRM assessments.
This resource will save you many hours work when trying to use Assessment for Learning in your class.
There are two QLA grids included in one Excel document for help with Gap Analysis.
Arithmetic
Reasoning
Input the data using the marks from the papers and the grid will change colour to show where a child has been successful or not answered a question correctly, or at all.
The spreadsheet will auto-calculate how successful the whole cohort has been on particular questions. These are linked directly to the WRM small steps so you can see which lessons and steps need to be revised. 30 children can be entered in this document.
The total score thresholds auto-calculate and change colour to help indicate which children are working at approximately an expected standard (EXS) level or a Greater Depth (GDS) level. These thresholds use historical KS2 SATs thresholds to make them as accurate as possible.
Please note, some of the cells are locked for editing so that users do not break the spreadsheet functionality. Passwords will not be given out. However, I am more than happy to assist with any adaptations you need.
Additionally, I am in no way affiliated with White Rose Maths. No White Rose Maths resources are included in this product. Freely available content is linked to within it.
A fun way to learn the Year 2 spellings. Each wordsearch focuses on a different phoneme/spelling pattern:
-Long (o) as –old, -ost and -oll
-ss words
-Long (i) as –ild and -ind
-ll words
-wa and squa
-ck words
-war and wor
-ff and zz words
-all
-ch words
-short (u) as o 1
-sh words
-short (u) as o 2
-th words
Three famous poems and reading comprehension questions to go with them. Questions include question types found in the 2016 and 2017 SATs papers or in End of Year assessments.
Poem 1 - The Fisherman - Abbie Farwell Brown
Poem 2 - Jabberwocky - Lewis Carroll
Poem 3 - Wynken, Blynken, and Nod - Eugene Field
I have used these as whole class exercises and for specific groups in guided reading to great effect.
Complete suite of Gap Analysis grids for the 2016 , 2017 & 2018 KS1 SATs. Reading, Maths and GPS papers for each year plus links to the matching assessments.
Please read each resources page for a more detailed breakdown of the contents.
These are excel spreadsheets Gap Analysis documents for the 2019 Year Two SATs Papers for GPS.
The sheet totals up the scores automatically and each child’s final score changes colour to reflect their ability.
If their total score for a subject goes green, it means they would have passed the 2019 SATs with that score. If it goes Purple, it means that child would have achieved a ‘Greater Depth’ score for that tested subject.
I have also included an instructions and document page, linking to a freely available copy of each test, mark scheme and instructions. Additionally, I have included a link to the conversion tables from RAW Score to Scaled Score.
All a teacher has to do is enter their children’s names and enter the 0’s, 1’s, 2’s or 3’s for each question, which also change colour too for a visual reference. I recommend that a teacher should enter ‘N’ if a child did not attempt that question. This gives an idea of who is not even attempting certain questions, not just whether they got the question wrong.
The sheets are set up for 32 pupils but more can be added/deleted and instructions are on the first page/sheet. Some cells are locked/protected in this document but the parts that you need to insert yourself are editable. This is so that the formulas/algorithms do not break and render the spreadsheet’s functionalities as broken.
I take requests for Gap Analysis Grids. Please leave feedback if you like this resource as I am planning to produce more for each SATs paper going forward, as well as CGP Practice Papers.
Please remember to rate this resource as I made this to save teachers time. Thank-you.